table of contents
mysql_refresh(3) | MariaDB Connector/C | mysql_refresh(3) |
Name¶
mysql_refresh - flushes information on the server
Synopsis¶
-
#include <mysql.h> int mysql_refresh(MYSQL * mysql, unsigned int options);
Description¶
Flushes different types of information stored on the server. The bit-masked parameter options specify which kind of information will be flushed.
Parameters¶
- •
- mysql - a mysql handle, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3).
- •
- options - a bit masked composed integer. See below.
options can be any combinationation of the following flags:
Option | Description |
REFRESH_GRANT | Refresh grant tables. |
REFRESH_LOG | Flush logs. |
REFRESH_TABLES | Flush table cache. |
REFRESH_HOSTS | Flush host cache. |
REFRESH_STATUS | Reset status variables. |
REFRESH_THREADS | Flush thread cache. |
REFRESH_SLAVE | Reset master server information and restart slaves. |
REFRESH_MASTER | Remove binary log files. |
Notes¶
- •
- To combine different values in the options parameter use the OR operator `|'.
- •
- mysql_reload() is an alias for mysql_refresh().
Return value¶
Returns zero on success, otherwise non zero.
Version 3.2.2 |